﻿CREATE TABLE [dbo].[Recycler_Customer] (
    [Id]                     INT              NOT NULL,
    [CompanyId]              INT              NULL,
    [CustomerId]             UNIQUEIDENTIFIER NULL,
    [CustomerName]           NVARCHAR (200)   NULL,
    [MnemonicWorks]          NVARCHAR (50)    NULL,
    [Project]                NVARCHAR (200)   NULL,
    [WebAddress]             VARCHAR (50)     NULL,
    [ZName]                  NVARCHAR (50)    NULL,
    [Tel]                    VARCHAR (50)     NULL,
    [Fax]                    VARCHAR (50)     NULL,
    [Pid]                    INT              NULL,
    [Cid]                    INT              NULL,
    [Rid]                    INT              NULL,
    [Address]                NVARCHAR (200)   NULL,
    [Zip]                    VARCHAR (50)     NULL,
    [IndustryOneId]          INT              NULL,
    [IndustryTwoId]          INT              NULL,
    [SourceId]               INT              NULL,
    [StateId]                INT              NULL,
    [TypeId]                 INT              NULL,
    [CreateName]             VARCHAR (50)     NULL,
    [CreateDate]             DATETIME         NULL,
    [ProtectId]              INT              NULL,
    [ProtectName]            VARCHAR (50)     NULL,
    [ProtectDate]            DATETIME         NULL,
    [TrackDate]              DATETIME         NULL,
    [Audit]                  BIT              NULL,
    [UpTime]                 DATETIME         NULL,
    [IntentionsId]           INT              NULL,
    [PublicityDemandId]      INT              NULL,
    [NetworkConsciousnessId] INT              NULL,
    [SalesPerson]            VARCHAR (50)     NULL,
    [ServicePerson]          VARCHAR (50)     NULL,
    [AuditPerson]            VARCHAR (50)     NULL,
    [delFlag]                SMALLINT         CONSTRAINT [DF_Recycler_Customer_delFlag] DEFAULT ((0)) NULL,
    [OrdersCount]            INT              CONSTRAINT [DF_Recycler_Customer_OrdersCount] DEFAULT ((0)) NULL,
    [ExtractDate]            INT              CONSTRAINT [DF_Recycler_Customer_ExtractDate] DEFAULT ((0)) NULL,
    [BDServicePerson]        VARCHAR (20)     CONSTRAINT [DF_Recycler_Customer_BDServicePerson] DEFAULT ('') NULL,
    [BDServicePersonEName]   NVARCHAR (50)    CONSTRAINT [DF_Recycler_Customer_BDServicePersonEName] DEFAULT ('') NULL,
    [BDServiceDate]          DATETIME         NULL,
    [ServicePersonEName]     NVARCHAR (50)    CONSTRAINT [DF_Recycler_Customer_ServicePersonEName] DEFAULT ('') NULL,
    [ServiceDate]            DATETIME         NULL,
    CONSTRAINT [PK_Recycler_Customer] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (FILLFACTOR = 90)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'百度客服人员编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Recycler_Customer', @level2type = N'COLUMN', @level2name = N'BDServicePerson';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'百度客服人员姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Recycler_Customer', @level2type = N'COLUMN', @level2name = N'BDServicePersonEName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'分配百度客服时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Recycler_Customer', @level2type = N'COLUMN', @level2name = N'BDServiceDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'维护客服姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Recycler_Customer', @level2type = N'COLUMN', @level2name = N'ServicePersonEName';

